USE [TIMEKEEPER]
GO

/****** Object:  StoredProcedure [dbo].[updateTerminalSetting]    Script Date: 02/04/2013 16:08:41 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[updateTerminalUserData] 
	@id numeric(8, 0),
	@backup numeric(2, 0),
	@machinePrivilege numeric(1, 0),
	@enrollData ntext,
	@status numeric(1,0),
	@createDateTime datetime,
	@updateDateTime datetime
AS
UPDATE [TIMEKEEPER].[dbo].[TERMINAL_USER_DATA]
   SET [ID] = @id
      ,[BACKUP_NO] = @backup
      ,[MACHINE_PRIVILEGE] = @machinePrivilege
      ,[ENROLL_DATA] = @enrollData
      ,[STATUS] = @status
      ,[CREATE_DATE_TIME] = @createDateTime
      ,[UPDATE_DATE_TIME] = @updateDateTime
 WHERE [ID] = @id

GO


